package com.ruoyi.baodao.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class MFGoods9999Example {
/*    // 临时增加
    public String getTmpTableName() {
        return tmpTableName;
    }
    // 临时增加
    public void setTmpTableName(String tmpTableName) {
        this.tmpTableName = tmpTableName;
    }

    // 临时增加
    private String tmpTableName;*/


    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public MFGoods9999Example() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andShopidIsNull() {
            addCriterion("shopid is null");
            return (Criteria) this;
        }

        public Criteria andShopidIsNotNull() {
            addCriterion("shopid is not null");
            return (Criteria) this;
        }

        public Criteria andShopidEqualTo(String value) {
            addCriterion("shopid =", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotEqualTo(String value) {
            addCriterion("shopid <>", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidGreaterThan(String value) {
            addCriterion("shopid >", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidGreaterThanOrEqualTo(String value) {
            addCriterion("shopid >=", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidLessThan(String value) {
            addCriterion("shopid <", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidLessThanOrEqualTo(String value) {
            addCriterion("shopid <=", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidLike(String value) {
            addCriterion("shopid like", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotLike(String value) {
            addCriterion("shopid not like", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidIn(List<String> values) {
            addCriterion("shopid in", values, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotIn(List<String> values) {
            addCriterion("shopid not in", values, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidBetween(String value1, String value2) {
            addCriterion("shopid between", value1, value2, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotBetween(String value1, String value2) {
            addCriterion("shopid not between", value1, value2, "shopid");
            return (Criteria) this;
        }

        public Criteria andGoodscodeIsNull() {
            addCriterion("goodsCode is null");
            return (Criteria) this;
        }

        public Criteria andGoodscodeIsNotNull() {
            addCriterion("goodsCode is not null");
            return (Criteria) this;
        }

        public Criteria andGoodscodeEqualTo(String value) {
            addCriterion("goodsCode =", value, "goodscode");
            return (Criteria) this;
        }

        public Criteria andGoodscodeNotEqualTo(String value) {
            addCriterion("goodsCode <>", value, "goodscode");
            return (Criteria) this;
        }

        public Criteria andGoodscodeGreaterThan(String value) {
            addCriterion("goodsCode >", value, "goodscode");
            return (Criteria) this;
        }

        public Criteria andGoodscodeGreaterThanOrEqualTo(String value) {
            addCriterion("goodsCode >=", value, "goodscode");
            return (Criteria) this;
        }

        public Criteria andGoodscodeLessThan(String value) {
            addCriterion("goodsCode <", value, "goodscode");
            return (Criteria) this;
        }

        public Criteria andGoodscodeLessThanOrEqualTo(String value) {
            addCriterion("goodsCode <=", value, "goodscode");
            return (Criteria) this;
        }

        public Criteria andGoodscodeLike(String value) {
            addCriterion("goodsCode like", value, "goodscode");
            return (Criteria) this;
        }

        public Criteria andGoodscodeNotLike(String value) {
            addCriterion("goodsCode not like", value, "goodscode");
            return (Criteria) this;
        }

        public Criteria andGoodscodeIn(List<String> values) {
            addCriterion("goodsCode in", values, "goodscode");
            return (Criteria) this;
        }

        public Criteria andGoodscodeNotIn(List<String> values) {
            addCriterion("goodsCode not in", values, "goodscode");
            return (Criteria) this;
        }

        public Criteria andGoodscodeBetween(String value1, String value2) {
            addCriterion("goodsCode between", value1, value2, "goodscode");
            return (Criteria) this;
        }

        public Criteria andGoodscodeNotBetween(String value1, String value2) {
            addCriterion("goodsCode not between", value1, value2, "goodscode");
            return (Criteria) this;
        }

        public Criteria andGoodsnameIsNull() {
            addCriterion("goodsName is null");
            return (Criteria) this;
        }

        public Criteria andGoodsnameIsNotNull() {
            addCriterion("goodsName is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsnameEqualTo(String value) {
            addCriterion("goodsName =", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameNotEqualTo(String value) {
            addCriterion("goodsName <>", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameGreaterThan(String value) {
            addCriterion("goodsName >", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameGreaterThanOrEqualTo(String value) {
            addCriterion("goodsName >=", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameLessThan(String value) {
            addCriterion("goodsName <", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameLessThanOrEqualTo(String value) {
            addCriterion("goodsName <=", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameLike(String value) {
            addCriterion("goodsName like", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameNotLike(String value) {
            addCriterion("goodsName not like", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameIn(List<String> values) {
            addCriterion("goodsName in", values, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameNotIn(List<String> values) {
            addCriterion("goodsName not in", values, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameBetween(String value1, String value2) {
            addCriterion("goodsName between", value1, value2, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameNotBetween(String value1, String value2) {
            addCriterion("goodsName not between", value1, value2, "goodsname");
            return (Criteria) this;
        }

        public Criteria andPyszIsNull() {
            addCriterion("pysz is null");
            return (Criteria) this;
        }

        public Criteria andPyszIsNotNull() {
            addCriterion("pysz is not null");
            return (Criteria) this;
        }

        public Criteria andPyszEqualTo(String value) {
            addCriterion("pysz =", value, "pysz");
            return (Criteria) this;
        }

        public Criteria andPyszNotEqualTo(String value) {
            addCriterion("pysz <>", value, "pysz");
            return (Criteria) this;
        }

        public Criteria andPyszGreaterThan(String value) {
            addCriterion("pysz >", value, "pysz");
            return (Criteria) this;
        }

        public Criteria andPyszGreaterThanOrEqualTo(String value) {
            addCriterion("pysz >=", value, "pysz");
            return (Criteria) this;
        }

        public Criteria andPyszLessThan(String value) {
            addCriterion("pysz <", value, "pysz");
            return (Criteria) this;
        }

        public Criteria andPyszLessThanOrEqualTo(String value) {
            addCriterion("pysz <=", value, "pysz");
            return (Criteria) this;
        }

        public Criteria andPyszLike(String value) {
            addCriterion("pysz like", value, "pysz");
            return (Criteria) this;
        }

        public Criteria andPyszNotLike(String value) {
            addCriterion("pysz not like", value, "pysz");
            return (Criteria) this;
        }

        public Criteria andPyszIn(List<String> values) {
            addCriterion("pysz in", values, "pysz");
            return (Criteria) this;
        }

        public Criteria andPyszNotIn(List<String> values) {
            addCriterion("pysz not in", values, "pysz");
            return (Criteria) this;
        }

        public Criteria andPyszBetween(String value1, String value2) {
            addCriterion("pysz between", value1, value2, "pysz");
            return (Criteria) this;
        }

        public Criteria andPyszNotBetween(String value1, String value2) {
            addCriterion("pysz not between", value1, value2, "pysz");
            return (Criteria) this;
        }

        public Criteria andNormIsNull() {
            addCriterion("norm is null");
            return (Criteria) this;
        }

        public Criteria andNormIsNotNull() {
            addCriterion("norm is not null");
            return (Criteria) this;
        }

        public Criteria andNormEqualTo(String value) {
            addCriterion("norm =", value, "norm");
            return (Criteria) this;
        }

        public Criteria andNormNotEqualTo(String value) {
            addCriterion("norm <>", value, "norm");
            return (Criteria) this;
        }

        public Criteria andNormGreaterThan(String value) {
            addCriterion("norm >", value, "norm");
            return (Criteria) this;
        }

        public Criteria andNormGreaterThanOrEqualTo(String value) {
            addCriterion("norm >=", value, "norm");
            return (Criteria) this;
        }

        public Criteria andNormLessThan(String value) {
            addCriterion("norm <", value, "norm");
            return (Criteria) this;
        }

        public Criteria andNormLessThanOrEqualTo(String value) {
            addCriterion("norm <=", value, "norm");
            return (Criteria) this;
        }

        public Criteria andNormLike(String value) {
            addCriterion("norm like", value, "norm");
            return (Criteria) this;
        }

        public Criteria andNormNotLike(String value) {
            addCriterion("norm not like", value, "norm");
            return (Criteria) this;
        }

        public Criteria andNormIn(List<String> values) {
            addCriterion("norm in", values, "norm");
            return (Criteria) this;
        }

        public Criteria andNormNotIn(List<String> values) {
            addCriterion("norm not in", values, "norm");
            return (Criteria) this;
        }

        public Criteria andNormBetween(String value1, String value2) {
            addCriterion("norm between", value1, value2, "norm");
            return (Criteria) this;
        }

        public Criteria andNormNotBetween(String value1, String value2) {
            addCriterion("norm not between", value1, value2, "norm");
            return (Criteria) this;
        }

        public Criteria andUnitIsNull() {
            addCriterion("unit is null");
            return (Criteria) this;
        }

        public Criteria andUnitIsNotNull() {
            addCriterion("unit is not null");
            return (Criteria) this;
        }

        public Criteria andUnitEqualTo(String value) {
            addCriterion("unit =", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotEqualTo(String value) {
            addCriterion("unit <>", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThan(String value) {
            addCriterion("unit >", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThanOrEqualTo(String value) {
            addCriterion("unit >=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThan(String value) {
            addCriterion("unit <", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThanOrEqualTo(String value) {
            addCriterion("unit <=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLike(String value) {
            addCriterion("unit like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotLike(String value) {
            addCriterion("unit not like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitIn(List<String> values) {
            addCriterion("unit in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotIn(List<String> values) {
            addCriterion("unit not in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitBetween(String value1, String value2) {
            addCriterion("unit between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotBetween(String value1, String value2) {
            addCriterion("unit not between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andMfrsIsNull() {
            addCriterion("mfrs is null");
            return (Criteria) this;
        }

        public Criteria andMfrsIsNotNull() {
            addCriterion("mfrs is not null");
            return (Criteria) this;
        }

        public Criteria andMfrsEqualTo(String value) {
            addCriterion("mfrs =", value, "mfrs");
            return (Criteria) this;
        }

        public Criteria andMfrsNotEqualTo(String value) {
            addCriterion("mfrs <>", value, "mfrs");
            return (Criteria) this;
        }

        public Criteria andMfrsGreaterThan(String value) {
            addCriterion("mfrs >", value, "mfrs");
            return (Criteria) this;
        }

        public Criteria andMfrsGreaterThanOrEqualTo(String value) {
            addCriterion("mfrs >=", value, "mfrs");
            return (Criteria) this;
        }

        public Criteria andMfrsLessThan(String value) {
            addCriterion("mfrs <", value, "mfrs");
            return (Criteria) this;
        }

        public Criteria andMfrsLessThanOrEqualTo(String value) {
            addCriterion("mfrs <=", value, "mfrs");
            return (Criteria) this;
        }

        public Criteria andMfrsLike(String value) {
            addCriterion("mfrs like", value, "mfrs");
            return (Criteria) this;
        }

        public Criteria andMfrsNotLike(String value) {
            addCriterion("mfrs not like", value, "mfrs");
            return (Criteria) this;
        }

        public Criteria andMfrsIn(List<String> values) {
            addCriterion("mfrs in", values, "mfrs");
            return (Criteria) this;
        }

        public Criteria andMfrsNotIn(List<String> values) {
            addCriterion("mfrs not in", values, "mfrs");
            return (Criteria) this;
        }

        public Criteria andMfrsBetween(String value1, String value2) {
            addCriterion("mfrs between", value1, value2, "mfrs");
            return (Criteria) this;
        }

        public Criteria andMfrsNotBetween(String value1, String value2) {
            addCriterion("mfrs not between", value1, value2, "mfrs");
            return (Criteria) this;
        }

        public Criteria andPzwhIsNull() {
            addCriterion("pzwh is null");
            return (Criteria) this;
        }

        public Criteria andPzwhIsNotNull() {
            addCriterion("pzwh is not null");
            return (Criteria) this;
        }

        public Criteria andPzwhEqualTo(String value) {
            addCriterion("pzwh =", value, "pzwh");
            return (Criteria) this;
        }

        public Criteria andPzwhNotEqualTo(String value) {
            addCriterion("pzwh <>", value, "pzwh");
            return (Criteria) this;
        }

        public Criteria andPzwhGreaterThan(String value) {
            addCriterion("pzwh >", value, "pzwh");
            return (Criteria) this;
        }

        public Criteria andPzwhGreaterThanOrEqualTo(String value) {
            addCriterion("pzwh >=", value, "pzwh");
            return (Criteria) this;
        }

        public Criteria andPzwhLessThan(String value) {
            addCriterion("pzwh <", value, "pzwh");
            return (Criteria) this;
        }

        public Criteria andPzwhLessThanOrEqualTo(String value) {
            addCriterion("pzwh <=", value, "pzwh");
            return (Criteria) this;
        }

        public Criteria andPzwhLike(String value) {
            addCriterion("pzwh like", value, "pzwh");
            return (Criteria) this;
        }

        public Criteria andPzwhNotLike(String value) {
            addCriterion("pzwh not like", value, "pzwh");
            return (Criteria) this;
        }

        public Criteria andPzwhIn(List<String> values) {
            addCriterion("pzwh in", values, "pzwh");
            return (Criteria) this;
        }

        public Criteria andPzwhNotIn(List<String> values) {
            addCriterion("pzwh not in", values, "pzwh");
            return (Criteria) this;
        }

        public Criteria andPzwhBetween(String value1, String value2) {
            addCriterion("pzwh between", value1, value2, "pzwh");
            return (Criteria) this;
        }

        public Criteria andPzwhNotBetween(String value1, String value2) {
            addCriterion("pzwh not between", value1, value2, "pzwh");
            return (Criteria) this;
        }

        public Criteria andPlucodeIsNull() {
            addCriterion("plucode is null");
            return (Criteria) this;
        }

        public Criteria andPlucodeIsNotNull() {
            addCriterion("plucode is not null");
            return (Criteria) this;
        }

        public Criteria andPlucodeEqualTo(String value) {
            addCriterion("plucode =", value, "plucode");
            return (Criteria) this;
        }

        public Criteria andPlucodeNotEqualTo(String value) {
            addCriterion("plucode <>", value, "plucode");
            return (Criteria) this;
        }

        public Criteria andPlucodeGreaterThan(String value) {
            addCriterion("plucode >", value, "plucode");
            return (Criteria) this;
        }

        public Criteria andPlucodeGreaterThanOrEqualTo(String value) {
            addCriterion("plucode >=", value, "plucode");
            return (Criteria) this;
        }

        public Criteria andPlucodeLessThan(String value) {
            addCriterion("plucode <", value, "plucode");
            return (Criteria) this;
        }

        public Criteria andPlucodeLessThanOrEqualTo(String value) {
            addCriterion("plucode <=", value, "plucode");
            return (Criteria) this;
        }

        public Criteria andPlucodeLike(String value) {
            addCriterion("plucode like", value, "plucode");
            return (Criteria) this;
        }

        public Criteria andPlucodeNotLike(String value) {
            addCriterion("plucode not like", value, "plucode");
            return (Criteria) this;
        }

        public Criteria andPlucodeIn(List<String> values) {
            addCriterion("plucode in", values, "plucode");
            return (Criteria) this;
        }

        public Criteria andPlucodeNotIn(List<String> values) {
            addCriterion("plucode not in", values, "plucode");
            return (Criteria) this;
        }

        public Criteria andPlucodeBetween(String value1, String value2) {
            addCriterion("plucode between", value1, value2, "plucode");
            return (Criteria) this;
        }

        public Criteria andPlucodeNotBetween(String value1, String value2) {
            addCriterion("plucode not between", value1, value2, "plucode");
            return (Criteria) this;
        }

        public Criteria andClassnameIsNull() {
            addCriterion("className is null");
            return (Criteria) this;
        }

        public Criteria andClassnameIsNotNull() {
            addCriterion("className is not null");
            return (Criteria) this;
        }

        public Criteria andClassnameEqualTo(String value) {
            addCriterion("className =", value, "classname");
            return (Criteria) this;
        }

        public Criteria andClassnameNotEqualTo(String value) {
            addCriterion("className <>", value, "classname");
            return (Criteria) this;
        }

        public Criteria andClassnameGreaterThan(String value) {
            addCriterion("className >", value, "classname");
            return (Criteria) this;
        }

        public Criteria andClassnameGreaterThanOrEqualTo(String value) {
            addCriterion("className >=", value, "classname");
            return (Criteria) this;
        }

        public Criteria andClassnameLessThan(String value) {
            addCriterion("className <", value, "classname");
            return (Criteria) this;
        }

        public Criteria andClassnameLessThanOrEqualTo(String value) {
            addCriterion("className <=", value, "classname");
            return (Criteria) this;
        }

        public Criteria andClassnameLike(String value) {
            addCriterion("className like", value, "classname");
            return (Criteria) this;
        }

        public Criteria andClassnameNotLike(String value) {
            addCriterion("className not like", value, "classname");
            return (Criteria) this;
        }

        public Criteria andClassnameIn(List<String> values) {
            addCriterion("className in", values, "classname");
            return (Criteria) this;
        }

        public Criteria andClassnameNotIn(List<String> values) {
            addCriterion("className not in", values, "classname");
            return (Criteria) this;
        }

        public Criteria andClassnameBetween(String value1, String value2) {
            addCriterion("className between", value1, value2, "classname");
            return (Criteria) this;
        }

        public Criteria andClassnameNotBetween(String value1, String value2) {
            addCriterion("className not between", value1, value2, "classname");
            return (Criteria) this;
        }

        public Criteria andClasscodeIsNull() {
            addCriterion("classCode is null");
            return (Criteria) this;
        }

        public Criteria andClasscodeIsNotNull() {
            addCriterion("classCode is not null");
            return (Criteria) this;
        }

        public Criteria andClasscodeEqualTo(String value) {
            addCriterion("classCode =", value, "classcode");
            return (Criteria) this;
        }

        public Criteria andClasscodeNotEqualTo(String value) {
            addCriterion("classCode <>", value, "classcode");
            return (Criteria) this;
        }

        public Criteria andClasscodeGreaterThan(String value) {
            addCriterion("classCode >", value, "classcode");
            return (Criteria) this;
        }

        public Criteria andClasscodeGreaterThanOrEqualTo(String value) {
            addCriterion("classCode >=", value, "classcode");
            return (Criteria) this;
        }

        public Criteria andClasscodeLessThan(String value) {
            addCriterion("classCode <", value, "classcode");
            return (Criteria) this;
        }

        public Criteria andClasscodeLessThanOrEqualTo(String value) {
            addCriterion("classCode <=", value, "classcode");
            return (Criteria) this;
        }

        public Criteria andClasscodeLike(String value) {
            addCriterion("classCode like", value, "classcode");
            return (Criteria) this;
        }

        public Criteria andClasscodeNotLike(String value) {
            addCriterion("classCode not like", value, "classcode");
            return (Criteria) this;
        }

        public Criteria andClasscodeIn(List<String> values) {
            addCriterion("classCode in", values, "classcode");
            return (Criteria) this;
        }

        public Criteria andClasscodeNotIn(List<String> values) {
            addCriterion("classCode not in", values, "classcode");
            return (Criteria) this;
        }

        public Criteria andClasscodeBetween(String value1, String value2) {
            addCriterion("classCode between", value1, value2, "classcode");
            return (Criteria) this;
        }

        public Criteria andClasscodeNotBetween(String value1, String value2) {
            addCriterion("classCode not between", value1, value2, "classcode");
            return (Criteria) this;
        }

        public Criteria andPrepntypeIsNull() {
            addCriterion("prepnType is null");
            return (Criteria) this;
        }

        public Criteria andPrepntypeIsNotNull() {
            addCriterion("prepnType is not null");
            return (Criteria) this;
        }

        public Criteria andPrepntypeEqualTo(String value) {
            addCriterion("prepnType =", value, "prepntype");
            return (Criteria) this;
        }

        public Criteria andPrepntypeNotEqualTo(String value) {
            addCriterion("prepnType <>", value, "prepntype");
            return (Criteria) this;
        }

        public Criteria andPrepntypeGreaterThan(String value) {
            addCriterion("prepnType >", value, "prepntype");
            return (Criteria) this;
        }

        public Criteria andPrepntypeGreaterThanOrEqualTo(String value) {
            addCriterion("prepnType >=", value, "prepntype");
            return (Criteria) this;
        }

        public Criteria andPrepntypeLessThan(String value) {
            addCriterion("prepnType <", value, "prepntype");
            return (Criteria) this;
        }

        public Criteria andPrepntypeLessThanOrEqualTo(String value) {
            addCriterion("prepnType <=", value, "prepntype");
            return (Criteria) this;
        }

        public Criteria andPrepntypeLike(String value) {
            addCriterion("prepnType like", value, "prepntype");
            return (Criteria) this;
        }

        public Criteria andPrepntypeNotLike(String value) {
            addCriterion("prepnType not like", value, "prepntype");
            return (Criteria) this;
        }

        public Criteria andPrepntypeIn(List<String> values) {
            addCriterion("prepnType in", values, "prepntype");
            return (Criteria) this;
        }

        public Criteria andPrepntypeNotIn(List<String> values) {
            addCriterion("prepnType not in", values, "prepntype");
            return (Criteria) this;
        }

        public Criteria andPrepntypeBetween(String value1, String value2) {
            addCriterion("prepnType between", value1, value2, "prepntype");
            return (Criteria) this;
        }

        public Criteria andPrepntypeNotBetween(String value1, String value2) {
            addCriterion("prepnType not between", value1, value2, "prepntype");
            return (Criteria) this;
        }

        public Criteria andExpireIsNull() {
            addCriterion("expire is null");
            return (Criteria) this;
        }

        public Criteria andExpireIsNotNull() {
            addCriterion("expire is not null");
            return (Criteria) this;
        }

        public Criteria andExpireEqualTo(String value) {
            addCriterion("expire =", value, "expire");
            return (Criteria) this;
        }

        public Criteria andExpireNotEqualTo(String value) {
            addCriterion("expire <>", value, "expire");
            return (Criteria) this;
        }

        public Criteria andExpireGreaterThan(String value) {
            addCriterion("expire >", value, "expire");
            return (Criteria) this;
        }

        public Criteria andExpireGreaterThanOrEqualTo(String value) {
            addCriterion("expire >=", value, "expire");
            return (Criteria) this;
        }

        public Criteria andExpireLessThan(String value) {
            addCriterion("expire <", value, "expire");
            return (Criteria) this;
        }

        public Criteria andExpireLessThanOrEqualTo(String value) {
            addCriterion("expire <=", value, "expire");
            return (Criteria) this;
        }

        public Criteria andExpireLike(String value) {
            addCriterion("expire like", value, "expire");
            return (Criteria) this;
        }

        public Criteria andExpireNotLike(String value) {
            addCriterion("expire not like", value, "expire");
            return (Criteria) this;
        }

        public Criteria andExpireIn(List<String> values) {
            addCriterion("expire in", values, "expire");
            return (Criteria) this;
        }

        public Criteria andExpireNotIn(List<String> values) {
            addCriterion("expire not in", values, "expire");
            return (Criteria) this;
        }

        public Criteria andExpireBetween(String value1, String value2) {
            addCriterion("expire between", value1, value2, "expire");
            return (Criteria) this;
        }

        public Criteria andExpireNotBetween(String value1, String value2) {
            addCriterion("expire not between", value1, value2, "expire");
            return (Criteria) this;
        }

        public Criteria andStandardcodeIsNull() {
            addCriterion("standardCode is null");
            return (Criteria) this;
        }

        public Criteria andStandardcodeIsNotNull() {
            addCriterion("standardCode is not null");
            return (Criteria) this;
        }

        public Criteria andStandardcodeEqualTo(String value) {
            addCriterion("standardCode =", value, "standardcode");
            return (Criteria) this;
        }

        public Criteria andStandardcodeNotEqualTo(String value) {
            addCriterion("standardCode <>", value, "standardcode");
            return (Criteria) this;
        }

        public Criteria andStandardcodeGreaterThan(String value) {
            addCriterion("standardCode >", value, "standardcode");
            return (Criteria) this;
        }

        public Criteria andStandardcodeGreaterThanOrEqualTo(String value) {
            addCriterion("standardCode >=", value, "standardcode");
            return (Criteria) this;
        }

        public Criteria andStandardcodeLessThan(String value) {
            addCriterion("standardCode <", value, "standardcode");
            return (Criteria) this;
        }

        public Criteria andStandardcodeLessThanOrEqualTo(String value) {
            addCriterion("standardCode <=", value, "standardcode");
            return (Criteria) this;
        }

        public Criteria andStandardcodeLike(String value) {
            addCriterion("standardCode like", value, "standardcode");
            return (Criteria) this;
        }

        public Criteria andStandardcodeNotLike(String value) {
            addCriterion("standardCode not like", value, "standardcode");
            return (Criteria) this;
        }

        public Criteria andStandardcodeIn(List<String> values) {
            addCriterion("standardCode in", values, "standardcode");
            return (Criteria) this;
        }

        public Criteria andStandardcodeNotIn(List<String> values) {
            addCriterion("standardCode not in", values, "standardcode");
            return (Criteria) this;
        }

        public Criteria andStandardcodeBetween(String value1, String value2) {
            addCriterion("standardCode between", value1, value2, "standardcode");
            return (Criteria) this;
        }

        public Criteria andStandardcodeNotBetween(String value1, String value2) {
            addCriterion("standardCode not between", value1, value2, "standardcode");
            return (Criteria) this;
        }

        public Criteria andYbcodeIsNull() {
            addCriterion("ybcode is null");
            return (Criteria) this;
        }

        public Criteria andYbcodeIsNotNull() {
            addCriterion("ybcode is not null");
            return (Criteria) this;
        }

        public Criteria andYbcodeEqualTo(String value) {
            addCriterion("ybcode =", value, "ybcode");
            return (Criteria) this;
        }

        public Criteria andYbcodeNotEqualTo(String value) {
            addCriterion("ybcode <>", value, "ybcode");
            return (Criteria) this;
        }

        public Criteria andYbcodeGreaterThan(String value) {
            addCriterion("ybcode >", value, "ybcode");
            return (Criteria) this;
        }

        public Criteria andYbcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ybcode >=", value, "ybcode");
            return (Criteria) this;
        }

        public Criteria andYbcodeLessThan(String value) {
            addCriterion("ybcode <", value, "ybcode");
            return (Criteria) this;
        }

        public Criteria andYbcodeLessThanOrEqualTo(String value) {
            addCriterion("ybcode <=", value, "ybcode");
            return (Criteria) this;
        }

        public Criteria andYbcodeLike(String value) {
            addCriterion("ybcode like", value, "ybcode");
            return (Criteria) this;
        }

        public Criteria andYbcodeNotLike(String value) {
            addCriterion("ybcode not like", value, "ybcode");
            return (Criteria) this;
        }

        public Criteria andYbcodeIn(List<String> values) {
            addCriterion("ybcode in", values, "ybcode");
            return (Criteria) this;
        }

        public Criteria andYbcodeNotIn(List<String> values) {
            addCriterion("ybcode not in", values, "ybcode");
            return (Criteria) this;
        }

        public Criteria andYbcodeBetween(String value1, String value2) {
            addCriterion("ybcode between", value1, value2, "ybcode");
            return (Criteria) this;
        }

        public Criteria andYbcodeNotBetween(String value1, String value2) {
            addCriterion("ybcode not between", value1, value2, "ybcode");
            return (Criteria) this;
        }

        public Criteria andFlag1IsNull() {
            addCriterion("flag1 is null");
            return (Criteria) this;
        }

        public Criteria andFlag1IsNotNull() {
            addCriterion("flag1 is not null");
            return (Criteria) this;
        }

        public Criteria andFlag1EqualTo(String value) {
            addCriterion("flag1 =", value, "flag1");
            return (Criteria) this;
        }

        public Criteria andFlag1NotEqualTo(String value) {
            addCriterion("flag1 <>", value, "flag1");
            return (Criteria) this;
        }

        public Criteria andFlag1GreaterThan(String value) {
            addCriterion("flag1 >", value, "flag1");
            return (Criteria) this;
        }

        public Criteria andFlag1GreaterThanOrEqualTo(String value) {
            addCriterion("flag1 >=", value, "flag1");
            return (Criteria) this;
        }

        public Criteria andFlag1LessThan(String value) {
            addCriterion("flag1 <", value, "flag1");
            return (Criteria) this;
        }

        public Criteria andFlag1LessThanOrEqualTo(String value) {
            addCriterion("flag1 <=", value, "flag1");
            return (Criteria) this;
        }

        public Criteria andFlag1Like(String value) {
            addCriterion("flag1 like", value, "flag1");
            return (Criteria) this;
        }

        public Criteria andFlag1NotLike(String value) {
            addCriterion("flag1 not like", value, "flag1");
            return (Criteria) this;
        }

        public Criteria andFlag1In(List<String> values) {
            addCriterion("flag1 in", values, "flag1");
            return (Criteria) this;
        }

        public Criteria andFlag1NotIn(List<String> values) {
            addCriterion("flag1 not in", values, "flag1");
            return (Criteria) this;
        }

        public Criteria andFlag1Between(String value1, String value2) {
            addCriterion("flag1 between", value1, value2, "flag1");
            return (Criteria) this;
        }

        public Criteria andFlag1NotBetween(String value1, String value2) {
            addCriterion("flag1 not between", value1, value2, "flag1");
            return (Criteria) this;
        }

        public Criteria andMadeTimeIsNull() {
            addCriterion("made_time is null");
            return (Criteria) this;
        }

        public Criteria andMadeTimeIsNotNull() {
            addCriterion("made_time is not null");
            return (Criteria) this;
        }

        public Criteria andMadeTimeEqualTo(Date value) {
            addCriterion("made_time =", value, "madeTime");
            return (Criteria) this;
        }

        public Criteria andMadeTimeNotEqualTo(Date value) {
            addCriterion("made_time <>", value, "madeTime");
            return (Criteria) this;
        }

        public Criteria andMadeTimeGreaterThan(Date value) {
            addCriterion("made_time >", value, "madeTime");
            return (Criteria) this;
        }

        public Criteria andMadeTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("made_time >=", value, "madeTime");
            return (Criteria) this;
        }

        public Criteria andMadeTimeLessThan(Date value) {
            addCriterion("made_time <", value, "madeTime");
            return (Criteria) this;
        }

        public Criteria andMadeTimeLessThanOrEqualTo(Date value) {
            addCriterion("made_time <=", value, "madeTime");
            return (Criteria) this;
        }

        public Criteria andMadeTimeIn(List<Date> values) {
            addCriterion("made_time in", values, "madeTime");
            return (Criteria) this;
        }

        public Criteria andMadeTimeNotIn(List<Date> values) {
            addCriterion("made_time not in", values, "madeTime");
            return (Criteria) this;
        }

        public Criteria andMadeTimeBetween(Date value1, Date value2) {
            addCriterion("made_time between", value1, value2, "madeTime");
            return (Criteria) this;
        }

        public Criteria andMadeTimeNotBetween(Date value1, Date value2) {
            addCriterion("made_time not between", value1, value2, "madeTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}